﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="工贸产量.aspx.cs" Inherits="syc.Juece.Report.工贸产量" %>
<%@ Import Namespace="NPOI.HSSF.UserModel" %>
<%@ Import Namespace="NPOI.HPSF" %>
<%@ Import Namespace="System.IO" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Configuration" %>
<html>
<head runat="server">
    <title></title>

    <style type="text/css">
        .style1
        {
            height: 20px;
        }
        .style2
        {
            height: 22px;
        }
        .style3
        {
            height: 38px;
        }
        .style4
        {
            width: 58px;
        }
        .style5
        {
            height: 20px;
            width: 58px;
        }
    </style>
</head>
<body>
<script runat="server">
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            this.Month.SelectedValue = DateTime.Today.Month.ToString();
            this.Year0.Text = DateTime.Today.Year.ToString();
            RiQi.Text = DateTime.Today.ToString("yyyy年M月d日");
        }
        Button_Query_Click(null, null);
    }
    protected void WriteToFile()
    {
        DateTime d;

        d = DateTime.Today;

        Response.ContentType = "application/ms-excel";
        Response.AddHeader("content-disposition", "attachment; filename=\"" + d.ToShortDateString() + ".xls\"");
        hssfworkbook.Write(Response.OutputStream);
    }
    protected void InitializeWorkbook()
    {

        FileStream file = new FileStream(HttpContext.Current.Server.MapPath("/JueCe/模板/主要产品产量表.xls"), FileMode.Open, FileAccess.Read);

        hssfworkbook = new HSSFWorkbook(file);

        DocumentSummaryInformation dsi = PropertySetFactory.CreateDocumentSummaryInformation();
        dsi.Company = "陕西延长石油材料有限公司";
        hssfworkbook.DocumentSummaryInformation = dsi;

        SummaryInformation si = PropertySetFactory.CreateSummaryInformation();
        si.Subject = "报表";
        si.Title = "主要产品产量表";
        hssfworkbook.SummaryInformation = si;
    }
    protected void Button_Query_Click(object sender, EventArgs e)
    {
        year = int.Parse(this.Year0.Text);
        SqlConnection Conn = new SqlConnection();
        Conn.ConnectionString = ConfigurationManager.ConnectionStrings["SCMConnectionString1"].ConnectionString;
        Conn.Open();
        SqlCommand Cmd = new SqlCommand();
        Cmd.Connection = Conn;
        //获得年计划
        Cmd.CommandText = @"select (isnull(二分厂产品1,0)+isnull(五分厂产品1,0)) as 月油管计划,(isnull(一分厂产品2,0)+isnull(二分厂产品2,0)) as 月套管计划,isnull(一分厂产品2,0) as 一分厂,isnull(二分厂产品1,0) as 二分厂油管,isnull(二分厂产品2,0) as 二分厂套管,isnull(五分厂产品1,0) as 五分厂,isnull(三分厂产品1,0) as 月油管接箍,isnull(三分厂产品2,0) as 月套管接箍,isnull(四分厂产品2,0) as 月保护器,isnull(一分厂产品4,0) from 生产计划 where 年度='" + year + "' and 月份=0";
        SqlDataReader Reader = Cmd.ExecuteReader();
        if (Reader.Read())
        {
            nyoujihua = Reader.GetDouble(0);
            ntaojihua = Reader.GetDouble(1);
            一分厂年计划 = Reader.GetDouble(2);
            二分厂油管年计划 = Reader.GetDouble(3);
            二分厂套管年计划 = Reader.GetDouble(4);
            五分厂年计划 = Reader.GetDouble(5);
            nyjiegujihua = Reader.GetDouble(6);
            ntjiegujihua = Reader.GetDouble(7);
            nbaohuqijihua = Reader.GetDouble(8);
            一分厂n80年计划 = Reader.GetDouble(9);
        }
        Reader.Close();
        //获得月计划
        Cmd.CommandText = @"select (isnull(二分厂产品1,0)+isnull(五分厂产品1,0)) as 月油管计划,(isnull(一分厂产品2,0)+isnull(二分厂产品2,0)) as 月套管计划,isnull(一分厂产品2,0) as 一分厂,isnull(二分厂产品1,0) as 二分厂油管,isnull(二分厂产品2,0) as 二分厂套管,isnull(五分厂产品1,0) as 五分厂,isnull(三分厂产品1,0) as 月油管接箍,isnull(三分厂产品2,0) as 月套管接箍,isnull(四分厂产品2,0) as 月保护器,isnull(一分厂产品4,0) from 生产计划 where 年度='" + year + "' and 月份='" + this.Month.Text + "'";
        Reader = Cmd.ExecuteReader();
        if (Reader.Read())
        {
            yyoujihua = Reader.GetDouble(0);
            ytaojihua = Reader.GetDouble(1);
            一分厂月计划 = Reader.GetDouble(2);
            二分厂油管月计划 = Reader.GetDouble(3);
            二分厂套管月计划 = Reader.GetDouble(4);
            五分厂月计划 = Reader.GetDouble(5);
            yyjiegujihua = Reader.GetDouble(6);
            ytjiegujihua = Reader.GetDouble(7);
            ybaohuqijihua = Reader.GetDouble(8);
            一分厂n80月计划 = Reader.GetDouble(9);
        }
        Reader.Close();
        //二分厂月油管量          
        string sql = @"
            declare @yc smalldatetime
            declare @ym smalldatetime
            declare @syc smalldatetime
            declare @sym smalldatetime            
            declare @y2you float
            declare @sy2you float
            select @yc=起始日期,@ym=截止日期 from 生产月设置
            where 分厂=2 and 年度='@年度' and 月份='@月份' 
            select @syc=起始日期,@sym=截止日期 from 生产月设置
            where 分厂=2 and 年度='@上年度' and 月份='@月份'             
            select @y2you=round(isnull(sum(入库重量),0)/1000,3) from 生产进度 where 分厂ID=2 and 产品类别ID=1 and 日期 between @yc and @ym
            select @sy2you=round(isnull(sum(入库重量),0)/1000,3) from 生产进度 where 分厂ID=2 and 产品类别ID=1 and 日期 between @syc and @sym
            select @y2you,@sy2you";
        sql = sql.Replace("@年度", year.ToString());
        sql = sql.Replace("@上年度", (year-1).ToString());
        sql = sql.Replace("@月份", this.Month.Text);
        Cmd.CommandText = sql;
        Reader = Cmd.ExecuteReader();
        if (Reader.Read())
        {
            y2you = Reader.GetDouble(0);
            sy2you = Reader.GetDouble(1);
        }
        Reader.Close();
        //五分厂月油管
        string sql1 = @"           
            declare @yc smalldatetime
            declare @ym smalldatetime
            declare @syc smalldatetime
            declare @sym smalldatetime                
            declare @y5you float
            declare @sy5you float          
                    
            select @yc=起始日期,@ym=截止日期 from 生产月设置
            where 分厂=5 and 年度='@年度' and 月份='@月份' 
            select @syc=起始日期,@sym=截止日期 from 生产月设置
            where 分厂=5 and 年度='@上年度' and 月份='@月份'             
            select @y5you=round(isnull(sum(入库重量),0)/1000,3) from 生产进度 where 分厂ID=5 and 产品类别ID=1 and 日期 between @yc and @ym
            select @sy5you=round(isnull(sum(入库重量),0)/1000,3) from 生产进度 where 分厂ID=5 and 产品类别ID=1 and 日期 between @syc and @sym
            select @y5you,@sy5you";
        sql1 = sql1.Replace("@年度", year.ToString());
        sql1 = sql1.Replace("@上年度", (year-1).ToString());
        sql1 = sql1.Replace("@月份", this.Month.Text);
        Cmd.CommandText = sql1;
        Reader = Cmd.ExecuteReader();
        if (Reader.Read())
        {
            y5you = Reader.GetDouble(0);
            sy5you = Reader.GetDouble(1);
        }
        //月油管
        yyou = y2you + y5you;
        syyou = sy2you + sy5you;
        Reader.Close();
        //一分厂月套管量
        string sql2 = @"
            declare @yc smalldatetime
            declare @ym smalldatetime
            declare @syc smalldatetime
            declare @sym smalldatetime            
            declare @y1tao float
            declare @sy1tao float            
            declare @y1taon80 float
            declare @sy1taon80 float            
            select @yc=起始日期,@ym=截止日期 from 生产月设置
            where 分厂=1 and 年度='@年度' and 月份='@月份'  
            select @syc=起始日期,@sym=截止日期 from 生产月设置
            where 分厂=1 and 年度='@上年度' and 月份='@月份'              
            select @y1tao=round(isnull(sum(入库重量),0)/1000,3) from 生产进度 where 分厂ID=1 and 产品类别ID=2 and 日期 between @yc and @ym
            select @y1taon80=round(isnull(sum(入库重量),0)/1000,3) from 生产进度 where 分厂ID=1 and 产品类别ID=4 and 日期 between @yc and @ym
            select @sy1tao=round(isnull(sum(入库重量),0)/1000,3) from 生产进度 where 分厂ID=1 and 产品类别ID=2 and 日期 between @syc and @sym
            select @sy1taon80=round(isnull(sum(入库重量),0)/1000,3) from 生产进度 where 分厂ID=1 and 产品类别ID=4 and 日期 between @syc and @sym            
            select @y1tao,@y1taon80,@sy1tao,@sy1taon80
             ";
        sql2 = sql2.Replace("@年度", year.ToString());
        sql2 = sql2.Replace("@上年度", (year-1).ToString());
        sql2 = sql2.Replace("@月份", this.Month.Text);
        Cmd.CommandText = sql2;
        Reader = Cmd.ExecuteReader();
        if (Reader.Read())
        {
            y1tao = Reader.GetDouble(0);
            y1taon80 = Reader.GetDouble(1);
            sy1tao = Reader.GetDouble(2);
            sy1taon80 = Reader.GetDouble(3);
        }
        Reader.Close();
        //二分厂月套管量
        string sql3 = @"
            declare @yc smalldatetime
            declare @ym smalldatetime
            declare @syc smalldatetime
            declare @sym smalldatetime            
            declare @y2tao float
            declare @y2n80tao float
            declare @sy2tao float
            declare @sy2n80tao float            
            select @yc=起始日期,@ym=截止日期 from 生产月设置
            where 分厂=2 and 年度='@年度' and 月份='@月份' 
            select @syc=起始日期,@sym=截止日期 from 生产月设置
            where 分厂=2 and 年度='@上年度' and 月份='@月份'               
            select @y2tao=round(isnull(sum(入库重量),0)/1000,3) from 生产进度 where 分厂ID=2 and 产品类别ID=2 and 日期 between @yc and @ym
            select @sy2tao=round(isnull(sum(入库重量),0)/1000,3) from 生产进度 where 分厂ID=2 and 产品类别ID=2 and 日期 between @syc and @sym
            select @y2tao,@sy2tao";
        sql3 = sql3.Replace("@年度", year.ToString());
        sql3 = sql3.Replace("@上年度", (year-1).ToString());
        sql3 = sql3.Replace("@月份", this.Month.Text);
        Cmd.CommandText = sql3;
        Reader = Cmd.ExecuteReader();
        if (Reader.Read())
        {
            y2tao = Reader.GetDouble(0);
            sy2tao = Reader.GetDouble(1);
        }
        Reader.Close();
        //月套管
        ytao = y1tao + y2tao+y1taon80;
        sytao = sy1tao + sy2tao + sy1taon80;
        //三分厂月油管接箍量
        string sql4 = @"
        select dbo.自产接箍本期收入(@年度,@月份,1) as 本期收入,dbo.自产接箍本期收入(@上年度,@月份,1) as 本期收入";
        sql4 = sql4.Replace("@年度", year.ToString());
        sql4 = sql4.Replace("@上年度", (year - 1).ToString());
        sql4 = sql4.Replace("@月份", this.Month.Text);
        Cmd.CommandText=sql4;
        Reader = Cmd.ExecuteReader();
        if (Reader.Read())
        {
            y3yjiegu = Reader.GetInt32(0);
            sy3yjiegu = Reader.GetInt32(1);
        }
        Reader.Close();
        //三分厂月套管接箍量
        string sql5 = @"
             select dbo.自产接箍本期收入(@年度,@月份,2)+dbo.自产接箍本期收入(@年度,@月份,4),dbo.自产接箍本期收入(@上年度,@月份,2)+dbo.自产接箍本期收入(@上年度,@月份,4)";
        sql5 = sql5.Replace("@年度", year.ToString());
        sql5 = sql5.Replace("@上年度", (year - 1).ToString());
        sql5 = sql5.Replace("@月份", this.Month.Text);
        Cmd.CommandText = sql5;
        Reader = Cmd.ExecuteReader();
        if (Reader.Read())
        {
            y3tjiegu = Reader.GetInt32(0);
            sy3tjiegu = Reader.GetInt32(1);
        }
        Reader.Close();
        yyjiegu = int.Parse(y3yjiegu.ToString());
        ytjiegu = int.Parse(y3tjiegu.ToString());
        syyjiegu = int.Parse(sy3yjiegu.ToString());
        sytjiegu = int.Parse(sy3tjiegu.ToString());
        //四分厂月保护器
        string sql6= @"
            declare @yc smalldatetime
            declare @ym smalldatetime
            declare @syc smalldatetime
            declare @sym smalldatetime  
            declare @保护器    int  
            declare @去年同期保护器    int                                              
            select @yc=起始日期,@ym=截止日期 from 生产月设置
            where 分厂=4 and 年度='@年度' and 月份='@月份' 
            select @syc=起始日期,@sym=截止日期 from 生产月设置
            where 分厂=4 and 年度='@上年度' and 月份='@月份'             
        select @保护器=isnull(sum(入库),0) from 生产进度4 where 产品类别ID=2 and 日期 between @yc and @ym
        select @去年同期保护器=isnull(sum(入库),0) from 生产进度4 where 产品类别ID=2 and 日期 between @syc and @sym
        select @保护器,@去年同期保护器        
        ";
        sql6 = sql6.Replace("@年度", year.ToString());
        sql6 = sql6.Replace("@上年度", (year - 1).ToString());
        sql6 = sql6.Replace("@月份", this.Month.Text);
        Cmd.CommandText = sql6;
        Reader = Cmd.ExecuteReader();
        if (Reader.Read())
        {
            y4baohuqi = Reader.GetInt32(0);
            sy4baohuqi = Reader.GetInt32(1);
        }
        Reader.Close();
        ybaohuqi = int.Parse(y4baohuqi.ToString());


        //二分厂年油管量          
        string sql7 = @"
            declare @nc smalldatetime
            declare @ym smalldatetime
            declare @snc smalldatetime
            declare @sym smalldatetime            
            declare @n2you float        
            declare @sn2you float                 
            select @nc=起始日期 from 生产月设置 where 年度='@年度' and 月份='1'and 分厂=2 
            select @ym=截止日期 from 生产月设置 where 年度='@年度' and 月份='@月份' and 分厂=2 
            select @snc=起始日期 from 生产月设置 where 年度='@上年度' and 月份='1'and 分厂=2 
            select @sym=截止日期 from 生产月设置 where 年度='@上年度' and 月份='@月份' and 分厂=2            
            select @n2you=round(isnull(sum(入库重量),0)/1000,3) from 生产进度 where 分厂ID=2 and 产品类别ID=1 and 日期 between @nc and @ym
            select @sn2you=round(isnull(sum(入库重量),0)/1000,3) from 生产进度 where 分厂ID=2 and 产品类别ID=1 and 日期 between @snc and @sym
            select @n2you,@sn2you";
        sql7 = sql7.Replace("@年度", year.ToString());
        sql7 = sql7.Replace("@上年度", (year-1).ToString());
        sql7 = sql7.Replace("@月份", this.Month.Text);
        Cmd.CommandText = sql7;
        Reader = Cmd.ExecuteReader();
        if (Reader.Read())
        {
            n2you = Reader.GetDouble(0);
            sn2you = Reader.GetDouble(1);
        }
        Reader.Close();
        //五分厂年油管
        string sql8 = @"
            declare @nc smalldatetime
            declare @ym smalldatetime
            declare @snc smalldatetime
            declare @sym smalldatetime            
            declare @n5you float           
            declare @sn5you float                      
            select @nc=起始日期 from 生产月设置 where  年度='@年度' and 月份='1'and 分厂=5 
            select @ym=截止日期 from 生产月设置 where  年度='@年度' and 月份='@月份' and 分厂=5 
            select @snc=起始日期 from 生产月设置 where  年度='@上年度' and 月份='1'and 分厂=5 
            select @sym=截止日期 from 生产月设置 where  年度='@上年度' and 月份='@月份' and 分厂=5             
            select @n5you=round(isnull(sum(入库重量),0)/1000,3) from 生产进度 where 分厂ID=5 and 产品类别ID=1 and 日期 between @nc and @ym
            select @sn5you=round(isnull(sum(入库重量),0)/1000,3) from 生产进度 where 分厂ID=5 and 产品类别ID=1 and 日期 between @snc and @sym
            select @n5you,@sn5you";
        sql8 = sql8.Replace("@年度", year.ToString());
        sql8 = sql8.Replace("@上年度", (year-1).ToString());
        sql8 = sql8.Replace("@月份", this.Month.Text);
        Cmd.CommandText = sql8;
        Reader = Cmd.ExecuteReader();
        if (Reader.Read())
        {
            n5you = Reader.GetDouble(0);
            sn5you = Reader.GetDouble(0);
        }
        //年油管
        nyou = n2you + n5you;
        snyou =sn2you + sn5you;
        Reader.Close();
        //一分厂年套管量
        string sql9= @"
            declare @nc smalldatetime
            declare @ym smalldatetime
            declare @snc smalldatetime
            declare @sym smalldatetime            
            declare @n1tao float
            declare @n1taon80 float
            declare @sn1tao float
            declare @sn1taon80 float            
            select @nc=起始日期 from 生产月设置 where 年度='@年度' and 月份='1'and 分厂=1 
            select @ym=截止日期 from 生产月设置 where 年度='@年度' and 月份='@月份' and 分厂=1 
            select @snc=起始日期 from 生产月设置 where 年度='@上年度' and 月份='1'and 分厂=1 
            select @sym=截止日期 from 生产月设置 where 年度='@上年度' and 月份='@月份' and 分厂=1             
            select @n1tao=round(isnull(sum(入库重量),0)/1000,3) from 生产进度 where 分厂ID=1 and 产品类别ID=2 and 日期 between @nc and @ym
            select @n1taon80=round(isnull(sum(入库重量),0)/1000,3) from 生产进度 where 分厂ID=1 and 产品类别ID=4 and 日期 between @nc and @ym
            select @sn1tao=round(isnull(sum(入库重量),0)/1000,3) from 生产进度 where 分厂ID=1 and 产品类别ID=2 and 日期 between @snc and @sym
            select @sn1taon80=round(isnull(sum(入库重量),0)/1000,3) from 生产进度 where 分厂ID=1 and 产品类别ID=4 and 日期 between @snc and @sym            
            select @n1tao,@n1taon80,@sn1tao,@sn1taon80";
        sql9 = sql9.Replace("@年度", year.ToString());
        sql9 = sql9.Replace("@上年度", (year-1).ToString());
        sql9 = sql9.Replace("@月份", this.Month.Text);
        Cmd.CommandText = sql9;
        Reader = Cmd.ExecuteReader();
        if (Reader.Read())
        {
            n1tao = Reader.GetDouble(0);
            n1taon80 = Reader.GetDouble(1);
            sn1tao = Reader.GetDouble(2);
            sn1taon80 = Reader.GetDouble(3);
        }
        Reader.Close();

        //二分厂年套管量
        string sql10 = @"
            declare @nc smalldatetime
            declare @ym smalldatetime
            declare @snc smalldatetime
            declare @sym smalldatetime           
            declare @n2tao float
            declare @n2n80tao float 
            declare @sn2tao float
            declare @sn2n80tao float             
            select @nc=起始日期 from 生产月设置 where 年度='@年度' and 月份='1'and 分厂=2 
            select @ym=截止日期 from 生产月设置 where 年度='@年度' and 月份='@月份' and 分厂=2 
            select @snc=起始日期 from 生产月设置 where 年度='@上年度' and 月份='1'and 分厂=2 
            select @sym=截止日期 from 生产月设置 where 年度='@上年度' and 月份='@月份' and 分厂=2             
            select @n2tao=round(isnull(sum(入库重量),0)/1000,3) from 生产进度 where 分厂ID=2 and 产品类别ID=2 and 日期 between @nc and @ym
            select @sn2tao=round(isnull(sum(入库重量),0)/1000,3) from 生产进度 where 分厂ID=2 and 产品类别ID=2 and 日期 between @snc and @sym
            select  @n2tao,@sn2tao";
        sql10 = sql10.Replace("@年度", year.ToString());
        sql10 = sql10.Replace("@上年度", (year-1).ToString());
        sql10 = sql10.Replace("@月份", this.Month.Text);
        Cmd.CommandText = sql10;
        Reader = Cmd.ExecuteReader();
        if (Reader.Read())
        {
            n2tao = Reader.GetDouble(0);
            sn2tao = Reader.GetDouble(1);
        }
        Reader.Close();
        //年套管
        ntao = n1tao + n2tao + n1taon80;
        sntao = sn1tao + sn2tao + sn1taon80;
        //三分厂年油管接箍量
        string sql11= @"
            select dbo.自产接箍本期累计收入(@年度,@月份,1),dbo.自产接箍本期累计收入(@上年度,@月份,1)          
";
        sql11 = sql11.Replace("@年度", year.ToString());
        sql11 = sql11.Replace("@上年度", (year - 1).ToString());
        sql11 = sql11.Replace("@月份", this.Month.Text);
        Cmd.CommandText = sql11;
        Reader = Cmd.ExecuteReader();
        if (Reader.Read())
        {
            n3yjiegu = Reader.GetInt32(0);
            sn3yjiegu = Reader.GetInt32(1);
        }
        Reader.Close();
        //三分厂年套管接箍量
        string sql12 = @"
             select dbo.自产接箍本期累计收入(@年度,@月份,2)+dbo.自产接箍本期累计收入(@年度,@月份,4),dbo.自产接箍本期累计收入(@上年度,@月份,2)+dbo.自产接箍本期累计收入(@上年度,@月份,4)
";
        sql12 = sql12.Replace("@年度", year.ToString());
        sql12 = sql12.Replace("@上年度", (year - 1).ToString());
        sql12 = sql12.Replace("@月份", this.Month.Text);
        Cmd.CommandText = sql12;

        Reader = Cmd.ExecuteReader();
        if (Reader.Read())
        {
            n3tjiegu = Reader.GetInt32(0);
            sn3tjiegu = Reader.GetInt32(1);
        }
        Reader.Close();
        nyjiegu = int.Parse(n3yjiegu.ToString());
        ntjiegu = int.Parse(n3tjiegu.ToString());
        snyjiegu = int.Parse(sn3yjiegu.ToString());
        sntjiegu = int.Parse(sn3tjiegu.ToString());
        //四分厂年保护器
        string sql13 = @"
            declare @nc smalldatetime
            declare @ym smalldatetime
            declare @snc smalldatetime
            declare @sym smalldatetime  
            declare @年保护器 int  
            declare @去年保护器 int                    
            select @nc=起始日期 from 生产月设置 where 年度='@年度' and 月份='1'and 分厂=4 
            select @ym=截止日期 from 生产月设置 where 年度='@年度' and 月份='@月份' and 分厂=4 
            select @snc=起始日期 from 生产月设置 where 年度='@上年度' and 月份='1'and 分厂=4 
            select @sym=截止日期 from 生产月设置 where 年度='@上年度' and 月份='@月份' and 分厂=4            
            select @年保护器=isnull(sum(入库),0) from 生产进度4 where 产品类别ID=2 and 日期 between @nc and @ym
            select @去年保护器=isnull(sum(入库),0) from 生产进度4 where 产品类别ID=2 and 日期 between @snc and @sym
            select @年保护器,@去年保护器";
        sql13 = sql13.Replace("@年度", year.ToString());
        sql13 = sql13.Replace("@上年度", (year - 1).ToString());
        sql13 = sql13.Replace("@月份", this.Month.Text);
        Cmd.CommandText = sql13;   

        Reader = Cmd.ExecuteReader();
        if (Reader.Read())
        {
            n4baohuqi = Reader.GetInt32(0);
            sn4baohuqi = Reader.GetInt32(1);
        }
        Reader.Close();
        nbaohuqi = int.Parse(n4baohuqi.ToString());
        snbaohuqi = int.Parse(sn4baohuqi.ToString());
        //带钢
        Cmd.CommandText =
@"select cast(isnull(年计划,0) as float) as 年计划
, cast(isnull(月计划,0) as float) as 月计划
,cast(isnull(本月,0) as float) as 本月
,cast(isnull(本年,0) as float) as 本年
from 精密带钢进度 where 日期='" + DateTime.Parse(this.RiQi.Text) + "'";
        Reader = Cmd.ExecuteReader();
        if (Reader.Read())
        {
            带钢年计划 = Reader.GetDouble(0);
            带钢月计划 = Reader.GetDouble(1);
            带钢本月完成 = Reader.GetDouble(2);
            带钢本年完成 = Reader.GetDouble(3);
            if (带钢月计划 > 0)
            {
                带钢本月完成率 = 带钢本月完成 / 带钢月计划 * 100;
            }
            if (带钢年计划 > 0)
            {
                带钢年完成率 = 带钢本年完成 / 带钢年计划 * 100;
            }
        }
        Reader.Close();
        //工业总产值
        string sql14 = @"           
            declare @油管月产值计划 float  
            declare @套管月产值计划 float  
            declare @套管N80月产值计划 float   
            declare @带钢月产值计划 float   
                                             
            select @油管月产值计划=isnull(sum(计划产值),0) from 工业总产值数据 where 产品类型ID=1 and 年份=@年度 and 月份= @月份
            select @套管月产值计划=isnull(sum(计划产值),0) from 工业总产值数据 where 产品类型ID=2 and 年份=@年度 and 月份= @月份 
            select @套管N80月产值计划=isnull(sum(计划产值),0) from 工业总产值数据 where 产品类型ID=4 and 年份=@年度 and 月份=@月份                                                                   
            select @带钢月产值计划=isnull(sum(计划产值),0) from 工业总产值数据 where 产品类型ID=3 and 年份=@年度 and 月份=@月份 
                   
            select @油管月产值计划,@套管月产值计划,@套管N80月产值计划,@带钢月产值计划";
        sql14 = sql14.Replace("@年度", year.ToString());     
        sql14 = sql14.Replace("@月份", this.Month.Text);
        Cmd.CommandText = sql14;

        Reader = Cmd.ExecuteReader();
        if (Reader.Read())
        {
            本月工业产值计划 = Reader.GetDouble(0) + Reader.GetDouble(1) + Reader.GetDouble(2) + Reader.GetDouble(3);            
        }
        Reader.Close();

        string sql15 = @"           
            declare @油管年产值计划 float  
            declare @套管年产值计划 float  
            declare @套管N80年产值计划 float   
            declare @带钢年产值计划 float   
                                             
            select @油管年产值计划=isnull(sum(计划产值),0) from 工业总产值数据 where 产品类型ID=1 and 年份=@年度 and 月份= @月份
            select @套管年产值计划=isnull(sum(计划产值),0) from 工业总产值数据 where 产品类型ID=2 and 年份=@年度 and 月份= @月份 
            select @套管N80年产值计划=isnull(sum(计划产值),0) from 工业总产值数据 where 产品类型ID=4 and 年份=@年度 and 月份=@月份                                                                   
            select @带钢年产值计划=isnull(sum(计划产值),0) from 工业总产值数据 where 产品类型ID=3 and 年份=@年度 and 月份=@月份 
                   
            select @油管年产值计划,@套管年产值计划,@套管N80年产值计划,@带钢年产值计划";
        sql15 = sql15.Replace("@年度", year.ToString());
        sql15 = sql15.Replace("@月份", "0");
        Cmd.CommandText = sql15;

        Reader = Cmd.ExecuteReader();
        if (Reader.Read())
        {
            本年工业产值计划 = Reader.GetDouble(0) + Reader.GetDouble(1) + Reader.GetDouble(2) + Reader.GetDouble(3);
        }
        Reader.Close();
        
        string sql16 = @"           
            declare @油管月产值 float  
            declare @套管月产值 float  
            declare @套管N80月产值 float   
            declare @带钢月产值 float    
            declare @油管s月产值 float  
            declare @套管s月产值 float  
            declare @套管N80s月产值 float   
            declare @带钢s月产值 float                                            
            select @油管月产值=isnull(sum(实际产值),0) from 工业总产值数据 where 产品类型ID=1 and 年份=@年度 and 月份= @月份
            select @套管月产值=isnull(sum(实际产值),0) from 工业总产值数据 where 产品类型ID=2 and 年份=@年度 and 月份= @月份 
            select @套管N80月产值=isnull(sum(实际产值),0) from 工业总产值数据 where 产品类型ID=4 and 年份=@年度 and 月份=@月份                                                                   
            select @带钢月产值=isnull(sum(实际产值),0) from 工业总产值数据 where 产品类型ID=3 and 年份=@年度 and 月份=@月份 

            select @油管s月产值=isnull(sum(实际产值),0) from 工业总产值数据 where 产品类型ID=1 and 年份=@上年度 and 月份=@月份
            select @套管s月产值=isnull(sum(实际产值),0) from 工业总产值数据 where 产品类型ID=2 and 年份=@上年度 and 月份= @月份 
            select @套管N80s月产值=isnull(sum(实际产值),0) from 工业总产值数据 where 产品类型ID=4 and 年份=@上年度 and 月份=@月份                                                                   
            select @带钢s月产值=isnull(sum(实际产值),0) from 工业总产值数据 where 产品类型ID=3 and 年份=@上年度 and 月份=@月份             
            
            select @油管月产值,@套管月产值,@套管N80月产值,@带钢月产值,@油管s月产值,@套管s月产值,@套管N80s月产值,@带钢s月产值";
        sql16 = sql16.Replace("@年度", year.ToString());
        sql16 = sql16.Replace("@上年度", (year - 1).ToString());
        sql16 = sql16.Replace("@月份", this.Month.Text);
        Cmd.CommandText = sql16;

        Reader = Cmd.ExecuteReader();
        if (Reader.Read())
        {
            本月工业产值 = Reader.GetDouble(0) + Reader.GetDouble(1) + Reader.GetDouble(2) + Reader.GetDouble(3);
            去年同期工业产值 = Reader.GetDouble(4) + Reader.GetDouble(5) + Reader.GetDouble(6) + Reader.GetDouble(7);
        }
        Reader.Close();
        
        string sql17 = @"           
            declare @油管年产值 float  
            declare @套管年产值 float  
            declare @套管N80年产值 float   
            declare @带钢年产值 float    
            declare @油管s年产值 float  
            declare @套管s年产值 float  
            declare @套管N80s年产值 float   
            declare @带钢s年产值 float                                            
            select @油管年产值=isnull(sum(实际产值),0) from 工业总产值数据 where 产品类型ID=1 and 年份=@年度 and 月份 between 1 and @月份
            select @套管年产值=isnull(sum(实际产值),0) from 工业总产值数据 where 产品类型ID=2 and 年份=@年度 and 月份 between 1 and @月份 
            select @套管N80年产值=isnull(sum(实际产值),0) from 工业总产值数据 where 产品类型ID=4 and 年份=@年度 and 月份 between 1 and @月份                                                                   
            select @带钢年产值=isnull(sum(实际产值),0) from 工业总产值数据 where 产品类型ID=3 and 年份=@年度 and 月份 between 1 and @月份 

            select @油管s年产值=isnull(sum(实际产值),0) from 工业总产值数据 where 产品类型ID=1 and 年份=@上年度 and 月份 between 1 and @月份
            select @套管s年产值=isnull(sum(实际产值),0) from 工业总产值数据 where 产品类型ID=2 and 年份=@上年度 and 月份 between 1 and @月份 
            select @套管N80s年产值=isnull(sum(实际产值),0) from 工业总产值数据 where 产品类型ID=4 and 年份=@上年度 and 月份 between 1 and @月份                                                                   
            select @带钢s年产值=isnull(sum(实际产值),0) from 工业总产值数据 where 产品类型ID=3 and 年份=@上年度 and 月份 between 1 and @月份             
            
            select @油管年产值,@套管年产值,@套管N80年产值,@带钢年产值,@油管s年产值,@套管s年产值,@套管N80s年产值,@带钢s年产值";
        sql17 = sql17.Replace("@年度", year.ToString());
        sql17 = sql17.Replace("@上年度", (year - 1).ToString());
        sql17 = sql17.Replace("@月份", this.Month.Text);
        Cmd.CommandText = sql17;

        Reader = Cmd.ExecuteReader();
        if (Reader.Read())
        {
            本月止工业产值 = Reader.GetDouble(0) + Reader.GetDouble(1) + Reader.GetDouble(2) + Reader.GetDouble(3);
            去年同期累计工业产值 = Reader.GetDouble(4) + Reader.GetDouble(5) + Reader.GetDouble(6) + Reader.GetDouble(7);
        }
        Reader.Close();
  
        
        if ((ytaojihua + yyoujihua) == 0)
        {
            油套管月完成率 = 0;
        }
        else
        {
            油套管月完成率 = ((yyou + ytao) / (ytaojihua + yyoujihua)) * 100;
        }
        if (yyoujihua == 0)
        {
            油管月完成率 = 0;
        }
        else
        {
            油管月完成率 = (yyou / yyoujihua) * 100;
        }
        if (ytaojihua == 0)
        {
            套管月完成率 = 0;
        }
        else
        {
            套管月完成率 = (ytao / ytaojihua) * 100;
        }
        if (一分厂月计划 == 0)
        {
            一分厂月完成率 = 0;
        }
        else
        {
            一分厂月完成率 = (y1tao / 一分厂月计划) * 100;
        }
        if (一分厂n80月计划 == 0)
        {
            一分厂n80月完成率 = 0;
        }
        else
        {
            一分厂n80月完成率 = (y1taon80 / 一分厂n80月计划) * 100;
        }
        if (二分厂油管月计划 == 0)
        {
            二分厂油管月完成率 = 0;
        }
        else
        {
            二分厂油管月完成率 = (y2you / 二分厂油管月计划) * 100;
        }
        if (二分厂套管月计划 == 0)
        {
            二分厂套管月完成率 = 0;
        }
        else
        {
            二分厂套管月完成率 = (y2tao / 二分厂套管月计划) * 100;
        }
        if (五分厂月计划 == 0)
        {
            五分厂月完成率 = 0;
        }
        else
        {
            五分厂月完成率 = (y5you / 五分厂月计划) * 100;
        }
        if (ytjiegujihua == 0)
        {
            套管接箍月完成率 = 0;
        }
        else
        {
            套管接箍月完成率 = (ytjiegu / ytjiegujihua) * 100;
        }
        if (yyjiegujihua == 0)
        {
            油管接箍月完成率 = 0;
        }
        else
        {
            油管接箍月完成率 = (yyjiegu / yyjiegujihua) * 100;
        }
        if (ybaohuqijihua == 0)
        {
            保护器月完成率 = 0;
        }
        else
        {
            保护器月完成率 = (ybaohuqi / ybaohuqijihua) * 100;
        }

        //------------------------------------------------------------

        if ((ntaojihua + nyoujihua) == 0)
        {
            油套管年完成率 = 0;
        }
        else
        {
            油套管年完成率 = ((nyou + ntao) / (ntaojihua + nyoujihua)) * 100;
        }
        if (nyoujihua == 0)
        {
            油管年完成率 = 0;
        }
        else
        {
            油管年完成率 = (nyou / nyoujihua) * 100;
        }
        if (ntaojihua == 0)
        {
            套管年完成率 = 0;
        }
        else
        {
            套管年完成率 = (ntao / ntaojihua) * 100;
        }
        if (一分厂年计划 == 0)
        {
            一分厂年完成率 = 0;
        }
        else
        {
            一分厂年完成率 = (n1tao / 一分厂年计划) * 100;
        }
        if (一分厂n80年计划 == 0)
        {
            一分厂n80年完成率 = 0;
        }
        else
        {
            一分厂n80年完成率 = (n1taon80 / 一分厂n80年计划) * 100;
        }
        if (二分厂油管年计划 == 0)
        {
            二分厂油管年完成率 = 0;
        }
        else
        {
            二分厂油管年完成率 = (n2you / 二分厂油管年计划) * 100;
        }
        if (二分厂套管年计划 == 0)
        {
            二分厂套管年完成率 = 0;
        }
        else
        {
            二分厂套管年完成率 = (n2tao / 二分厂套管年计划) * 100;
        }
        if (五分厂年计划 == 0)
        {
            五分厂年完成率 = 0;
        }
        else
        {
            五分厂年完成率 = (n5you / 五分厂年计划) * 100;
        }
        if (ntjiegujihua == 0)
        {
            套管接箍年完成率 = 0;
        }
        else
        {
            套管接箍年完成率 = (ntjiegu / ntjiegujihua) * 100;
        }
        if (nyjiegujihua == 0)
        {
            油管接箍年完成率 = 0;
        }
        else
        {
            油管接箍年完成率 = (nyjiegu / nyjiegujihua) * 100;
        }
        if (nbaohuqijihua == 0)
        {
            保护器年完成率 = 0;
        }
        else
        {
            保护器年完成率 = (nbaohuqi / nbaohuqijihua) * 100;
        }
        if (带钢去年同期 == 0)
        {
            带钢去年同比增长 = -100;
        }
        else
        {
            带钢去年同比增长 = ((带钢本年完成 / 带钢去年同期) - 1) * 100;
        }
        if (snyou == 0)
        {
            油管同比增长率 = 0;
        }
        else
        {
            油管同比增长率 = ((nyou / snyou) - 1) * 100;
        }
        if (sntao == 0)
        {
            套管同比增长率 = 0;
        }
        else
        {
            套管同比增长率 = ((ntao / sntao) - 1) * 100;
        }
        if (snyjiegu == 0)
        {
            油管接箍同比增长率 = 0;
        }
        else
        {
            油管接箍同比增长率 = ((double.Parse(nyjiegu.ToString()) / double.Parse(snyjiegu.ToString())-1)) * 100;
        }
        if (sntjiegu == 0)
        {
            套管接箍同比增长率 = 0;
        }
        else
        {
            套管接箍同比增长率 = ((double.Parse(ntjiegu.ToString()) / double.Parse(sntjiegu.ToString()) - 1)) * 100;
        }
        if (snbaohuqi == 0)
        {
            螺纹保护器同比增长率 = 0;
        }
        else
        {
            螺纹保护器同比增长率 = ((double.Parse(nbaohuqi.ToString()) / double.Parse(snbaohuqi.ToString()) - 1)) * 100;
        }
        if (本月工业产值计划 == 0)
        {
            本月工业产值完成率 = 0;
        }
        else
        {
            本月工业产值完成率=(本月工业产值/本月工业产值计划)*100;
        }
        if (本年工业产值计划 == 0)
        {
            本年工业产值完成率 = 0;
        }
        else
        {
            本年工业产值完成率 = (本月止工业产值 / 本年工业产值计划) * 100;
        }
        if (去年同期累计工业产值 == 0)
        {
            工业产值同比增长率 = 0;
        }
        else
        {
            工业产值同比增长率 = ((本月止工业产值/去年同期累计工业产值 ) - 1) * 100;
        }
        Conn.Close();
        Reader.Dispose();
        Cmd.Dispose();
        Conn.Dispose();
    }

    protected void Button_Save_Click(object sender, EventArgs e)
    {
        InitializeWorkbook();
        HSSFSheet sheet1 = hssfworkbook.GetSheet("主要产品产量表");
        Button_Query_Click(null, null);      
        sheet1.GetRow(1).GetCell(4).SetCellValue(DateTime.Today.Year + "年" + DateTime.Today.Month + "月");
        sheet1.GetRow(4).GetCell(2).SetCellValue(本月工业产值计划);
        sheet1.GetRow(4).GetCell(3).SetCellValue(本月工业产值);
        sheet1.GetRow(4).GetCell(4).SetCellValue(本月工业产值完成率.ToString("0.00"));
        sheet1.GetRow(4).GetCell(5).SetCellValue(本年工业产值计划);
        sheet1.GetRow(4).GetCell(6).SetCellValue(本月止工业产值);
        sheet1.GetRow(4).GetCell(7).SetCellValue(本年工业产值完成率.ToString("0.00"));
        sheet1.GetRow(4).GetCell(8).SetCellValue(去年同期工业产值);
        sheet1.GetRow(4).GetCell(9).SetCellValue(去年同期累计工业产值);
        sheet1.GetRow(4).GetCell(10).SetCellValue(工业产值同比增长率.ToString("0.00"));

        sheet1.GetRow(5).GetCell(2).SetCellValue(yyoujihua);
        sheet1.GetRow(5).GetCell(3).SetCellValue(yyou);
        sheet1.GetRow(5).GetCell(4).SetCellValue(油管月完成率.ToString("0.00"));
        sheet1.GetRow(5).GetCell(5).SetCellValue(nyoujihua);
        sheet1.GetRow(5).GetCell(6).SetCellValue(nyou);
        sheet1.GetRow(5).GetCell(7).SetCellValue(油管年完成率.ToString("0.00"));
        sheet1.GetRow(5).GetCell(8).SetCellValue(syyou);
        sheet1.GetRow(5).GetCell(9).SetCellValue(snyou);
        sheet1.GetRow(5).GetCell(10).SetCellValue(油管同比增长率.ToString("0.00"));
        
        sheet1.GetRow(6).GetCell(2).SetCellValue(ytaojihua);
        sheet1.GetRow(6).GetCell(3).SetCellValue(ytao);
        sheet1.GetRow(6).GetCell(4).SetCellValue(套管月完成率.ToString("0.00"));
        sheet1.GetRow(6).GetCell(5).SetCellValue(ntaojihua);
        sheet1.GetRow(6).GetCell(6).SetCellValue(ntao);
        sheet1.GetRow(6).GetCell(7).SetCellValue(套管年完成率.ToString("0.00"));
        sheet1.GetRow(6).GetCell(8).SetCellValue(sytao);
        sheet1.GetRow(6).GetCell(9).SetCellValue(sntao);
        sheet1.GetRow(6).GetCell(10).SetCellValue(套管同比增长率.ToString("0.00"));

        sheet1.GetRow(7).GetCell(2).SetCellValue(yyjiegujihua);
        sheet1.GetRow(7).GetCell(3).SetCellValue(yyjiegu);
        sheet1.GetRow(7).GetCell(4).SetCellValue(油管接箍月完成率.ToString("0.00"));
        sheet1.GetRow(7).GetCell(5).SetCellValue(nyjiegujihua);
        sheet1.GetRow(7).GetCell(6).SetCellValue(nyjiegu);
        sheet1.GetRow(7).GetCell(7).SetCellValue(油管接箍年完成率.ToString("0.00"));
        sheet1.GetRow(7).GetCell(8).SetCellValue(syyjiegu);
        sheet1.GetRow(7).GetCell(9).SetCellValue(snyjiegu);
        sheet1.GetRow(7).GetCell(10).SetCellValue(油管接箍同比增长率.ToString("0.00"));

        sheet1.GetRow(8).GetCell(2).SetCellValue(ytjiegujihua);
        sheet1.GetRow(8).GetCell(3).SetCellValue(ytjiegu);
        sheet1.GetRow(8).GetCell(4).SetCellValue(套管接箍月完成率.ToString("0.00"));
        sheet1.GetRow(8).GetCell(5).SetCellValue(ntjiegujihua);
        sheet1.GetRow(8).GetCell(6).SetCellValue(ntjiegu);
        sheet1.GetRow(8).GetCell(7).SetCellValue(套管接箍年完成率.ToString("0.00"));
        sheet1.GetRow(8).GetCell(8).SetCellValue(sytjiegu);
        sheet1.GetRow(8).GetCell(9).SetCellValue(sntjiegu);
        sheet1.GetRow(8).GetCell(10).SetCellValue(套管接箍同比增长率.ToString("0.00"));

        sheet1.GetRow(9).GetCell(2).SetCellValue(ybaohuqijihua);
        sheet1.GetRow(9).GetCell(3).SetCellValue(ybaohuqi);
        sheet1.GetRow(9).GetCell(4).SetCellValue(保护器月完成率.ToString("0.00"));
        sheet1.GetRow(9).GetCell(5).SetCellValue(nbaohuqijihua);
        sheet1.GetRow(9).GetCell(6).SetCellValue(nbaohuqi);
        sheet1.GetRow(9).GetCell(7).SetCellValue(保护器年完成率.ToString("0.00"));
        sheet1.GetRow(9).GetCell(8).SetCellValue(sybaohuqi);
        sheet1.GetRow(9).GetCell(9).SetCellValue(snbaohuqi);
        sheet1.GetRow(9).GetCell(10).SetCellValue(螺纹保护器同比增长率.ToString("0.00"));

        sheet1.GetRow(10).GetCell(2).SetCellValue(带钢月计划);
        sheet1.GetRow(10).GetCell(3).SetCellValue(带钢本月完成);
        sheet1.GetRow(10).GetCell(4).SetCellValue(带钢本月完成率.ToString("0.00"));
        sheet1.GetRow(10).GetCell(5).SetCellValue(带钢年计划);
        sheet1.GetRow(10).GetCell(6).SetCellValue(带钢本年完成);
        sheet1.GetRow(10).GetCell(7).SetCellValue(带钢年完成率.ToString("0.00"));
        
        sheet1.GetRow(20).GetCell(9).SetCellValue("报出日期："+DateTime.Today.Year + "-" + DateTime.Today.Month + "-" + DateTime.Today.Day);  
        WriteToFile();
        Response.End();
    }
    
    
</script>
     <script type="text/javascript" language="javascript" src="/common.js"></script>
    <form id="form1" runat="server">
    <div id="wintop" class="wintop">陕西延长石油材料公司主要产品产量表</div>
        <asp:Panel ID="Panel3" runat="server" CssClass="panel">
              年份：<asp:DropDownList ID="Year0" runat="server" AutoPostBack="true">
            <asp:ListItem>2009</asp:ListItem>
            <asp:ListItem>2010</asp:ListItem>
            <asp:ListItem>2011</asp:ListItem>
            <asp:ListItem>2012</asp:ListItem>
            <asp:ListItem>2013</asp:ListItem>
            <asp:ListItem>2014</asp:ListItem>
            <asp:ListItem>2015</asp:ListItem>           
            </asp:DropDownList>
            <span lang="zh-cn">&nbsp;月份：</span><asp:DropDownList ID="Month" runat="server"  AutoPostBack="true">
                <asp:ListItem>1</asp:ListItem>
                <asp:ListItem>2</asp:ListItem>
                <asp:ListItem>3</asp:ListItem>
                <asp:ListItem>4</asp:ListItem>
                <asp:ListItem>5</asp:ListItem>
                <asp:ListItem>6</asp:ListItem>
                <asp:ListItem>7</asp:ListItem>
                <asp:ListItem>8</asp:ListItem>
                <asp:ListItem>9</asp:ListItem>
                <asp:ListItem>10</asp:ListItem>
                <asp:ListItem>11</asp:ListItem>
                <asp:ListItem>12</asp:ListItem>
            </asp:DropDownList>
            <span lang="zh-cn">&nbsp;&nbsp;填报日期：<asp:TextBox ID="RiQi" runat="server" 
                  AutoPostBack="true" CssClass="intxt1" Width="110px"></asp:TextBox><img align="middle" alt="" 
                  onclick="makecalendar(document.getElementById('RiQi').value, document.getElementById('RiQi'));" 
                  src="../../../../../../../../../Icons/29.png" /> &nbsp;</span><asp:Button ID="Button_Query" Visible="false"
            runat="server" Text="查看报表" CssClass="button" UseSubmitBehavior="true" onclick="Button_Query_Click" 
             />
            <asp:Button ID="Button_Save" runat="server" Text="导出报表" CssClass="button" 
                UseSubmitBehavior="False" onclick="Button_Save_Click"/>
        </asp:Panel>
        <asp:Panel ID="Panel2" runat="server" CssClass="panel2">
            <asp:Label ID="Message" runat="server" Text="·准备就绪" CssClass="prompt"></asp:Label>
        </asp:Panel>

<asp:Panel ID="Panel4" runat="server" CssClass="panel3">
<br />
<style>
<!--table
	{mso-displayed-decimal-separator:"\.";
	mso-displayed-thousand-separator:"\,";}
@page
	{margin:.79in .75in .59in .75in;
	mso-header-margin:.51in;
	mso-footer-margin:.51in;
	mso-page-orientation:landscape;
	mso-horizontal-page-align:center;
	mso-vertical-page-align:center;}
tr
	{mso-height-source:auto;
	mso-ruby-visibility:none;}
col
	{mso-width-source:auto;
	mso-ruby-visibility:none;}
br
	{mso-data-placement:same-cell;}
.style0
	{mso-number-format:General;
	text-align:general;
	vertical-align:bottom;
	white-space:nowrap;
	mso-rotate:0;
	mso-background-source:auto;
	mso-pattern:auto;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial, sans-serif;
	mso-font-charset:0;
	border:none;
	mso-protection:locked visible;
	mso-style-name:"";}
.style0
	{mso-number-format:General;
	text-align:general;
	vertical-align:bottom;
	white-space:nowrap;
	mso-rotate:0;
	mso-background-source:auto;
	mso-pattern:auto;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial, sans-serif;
	mso-font-charset:0;
	border:none;
	mso-protection:locked visible;
	mso-style-name:常规;
	mso-style-id:0;}
.style17
	{mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	white-space:nowrap;
	mso-rotate:0;
	mso-background-source:auto;
	mso-pattern:auto;
	color:windowtext;
	font-size:12.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	border:none;
	mso-protection:locked visible;
	mso-style-name:常规_Sheet1;}
td
	{mso-style-parent:style0;
	padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:12.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	border:none;
	mso-background-source:auto;
	mso-pattern:auto;
	mso-protection:locked visible;
	white-space:nowrap;
	mso-rotate:0;}
.xl26
	{mso-style-parent:style0;
	vertical-align:bottom;}
.xl27
	{mso-style-parent:style0;
	font-size:10.0pt;
	vertical-align:bottom;}
.xl28
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:center;
	border:.5pt solid windowtext;}
.xl29
	{mso-style-parent:style17;
	font-size:10.0pt;
	text-align:center;
	border:.5pt solid windowtext;}
.xl30
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:right;
	border:.5pt solid windowtext;}
.xl31
	{mso-style-parent:style0;
	font-size:10.0pt;
	mso-number-format:"0_ ";
	text-align:right;
	border:.5pt solid windowtext;}
.xl32
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:left;
	border:.5pt solid windowtext;}
.xl33
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:center;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl34
	{mso-style-parent:style0;
	color:maroon;
	font-size:10.0pt;
	mso-number-format:"0\.00_ ";
	text-align:center;
	border:.5pt solid windowtext;}
.xl35
	{mso-style-parent:style0;
	color:maroon;
	font-size:10.0pt;
	mso-number-format:"0_ ";
	text-align:center;
	border:.5pt solid windowtext;}
.xl36
	{mso-style-parent:style0;
	font-size:20.0pt;
	font-weight:700;
	text-align:center;}
.xl37
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:left;
	border-top:none;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;}
.xl38
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:center;
	border-top:none;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;}
.xl39
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:right;
	border-top:none;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;}
.xl40
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:left;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:none;
	border-left:none;
	mso-background-source:auto;
	mso-pattern:auto;}
.xl41
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:none;
	border-left:none;}
.xl42
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:none;
	border-left:none;
	mso-background-source:auto;
	mso-pattern:auto;}
.xl43
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:center;
	border:.5pt solid windowtext;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:normal;}
.xl44
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:center;
	border:.5pt solid windowtext;
	mso-background-source:auto;
	mso-pattern:auto;}
ruby
	{ruby-align:left;}
rt
	{color:windowtext;
	font-size:9.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-char-type:none;
	display:none;}
-->
</style>
<!--[if gte mso 9]><xml>
 <x:ExcelWorkbook>
  <x:ExcelWorksheets>
   <x:ExcelWorksheet>
    <x:Name>产品产量</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>285</x:DefaultRowHeight>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>600</x:HorizontalResolution>
      <x:VerticalResolution>600</x:VerticalResolution>
     </x:Print>
     <x:Selected/>
     <x:Panes>
      <x:Pane>
       <x:Number>3</x:Number>
       <x:ActiveRow>14</x:ActiveRow>
       <x:ActiveCol>4</x:ActiveCol>
      </x:Pane>
     </x:Panes>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
  </x:ExcelWorksheets>
  <x:WindowHeight>3510</x:WindowHeight>
  <x:WindowWidth>15480</x:WindowWidth>
  <x:WindowTopX>-15</x:WindowTopX>
  <x:WindowTopY>-15</x:WindowTopY>
  <x:ProtectStructure>False</x:ProtectStructure>
  <x:ProtectWindows>False</x:ProtectWindows>
 </x:ExcelWorkbook>
</xml><![endif]-->
</head>

<body link=blue vlink=purple class=xl26>

<table x:str border=0 cellpadding=0 cellspacing=0 width=935 style='border-collapse:
 collapse;table-layout:fixed;width:704pt'>
 <col width=117 style='mso-width-source:userset;mso-width-alt:3744;width:88pt'>
 <col width=53 style='mso-width-source:userset;mso-width-alt:1696;width:40pt'>
 <col width=85 span=9 style='mso-width-source:userset;mso-width-alt:2720;
 width:64pt'>
 <tr height=44 style='mso-height-source:userset;height:33.0pt'>
  <td colspan=11 height=44 class=xl36 width=935 style='height:33.0pt;
  width:704pt'>主要产品产量表</td>
 </tr>
 <tr class=xl27 height=29 style='mso-height-source:userset;height:21.95pt'>
  <td colspan=2 height=29 class=xl37 style='height:21.95pt'>填报单位：材料公司</td>
  <td colspan=7 class=xl38>2011年 3 月</td>
  <td colspan=2 class=xl39>陕油统 材料B－1501</td>
 </tr>
 <tr height=29 style='mso-height-source:userset;height:21.95pt'>
  <td rowspan=2 height=58 class=xl28 style='height:43.9pt;border-top:none'>产品名称</td>
  <td rowspan=2 class=xl28 style='border-top:none'>单位</td>
  <td colspan=3 class=xl28 style='border-left:none'>本月生产</td>
  <td colspan=3 class=xl28 style='border-left:none'>本年生产</td>
  <td rowspan=2 class=xl43 width=85 style='border-top:none;width:64pt'>去年<br>
    同期</td>
  <td rowspan=2 class=xl43 width=85 style='border-top:none;width:64pt'>去年同<br>
    期累计</td>
  <td rowspan=2 class=xl43 width=85 style='border-top:none;width:64pt'>同
  比<br>
    增长率%</td>
 </tr>
 <tr height=29 style='mso-height-source:userset;height:21.95pt'>
  <td height=29 class=xl28 style='height:21.95pt;border-top:none;border-left:
  none'>月计划</td>
  <td class=xl28 style='border-top:none;border-left:none'>月完成</td>
  <td class=xl28 style='border-top:none;border-left:none'>完成率%</td>
  <td class=xl28 style='border-top:none;border-left:none'>年计划</td>
  <td class=xl28 style='border-top:none;border-left:none'>年完成</td>
  <td class=xl28 style='border-top:none;border-left:none'>完成率%</td>
 </tr>
 <tr height=29 style='mso-height-source:userset;height:21.95pt'>
  <td height=29 class=xl29 style='height:21.95pt;border-top:none'>工业总产值</td>
  <td class=xl28 style='border-top:none;border-left:none'>万元</td>
  <td class=xl28 style='border-top:none;border-left:none'><%=本月工业产值计划 %></td>
  <td class=xl28 style='border-top:none;border-left:none'><%=本月工业产值%></td>
  <td class=xl34 style='border-top:none;border-left:none'><%=本月工业产值完成率.ToString("0.00") %></td>
  <td class=xl35 style='border-top:none;border-left:none'><%=本年工业产值计划%></td>
  <td class=xl28 style='border-top:none;border-left:none'><%=本月止工业产值%></td>
  <td class=xl34 style='border-top:none;border-left:none'><%=本年工业产值完成率.ToString("0.00") %></td>
  <td class=xl28 style='border-top:none;border-left:none'><%=去年同期工业产值%></td>
  <td class=xl28 style='border-top:none;border-left:none'><%=去年同期累计工业产值%></td>
  <td class=xl34 style='border-top:none;border-left:none'><%=工业产值同比增长率.ToString("0.00")%></td>
 </tr>
 <tr height=29 style='mso-height-source:userset;height:21.95pt'>
  <td height=29 class=xl29 style='height:21.95pt;border-top:none'>石油油管</td>
  <td class=xl28 style='border-top:none;border-left:none'>吨</td>
  <td class=xl28 style='border-top:none;border-left:none'><%=yyoujihua%></td>
  <td class=xl28 style='border-top:none;border-left:none'><%=yyou%></td>
  <td class=xl34 style='border-top:none;border-left:none'><%=油管月完成率.ToString("0.00") %></td>
  <td class=xl35 style='border-top:none;border-left:none'><%=nyoujihua%></td>
  <td class=xl28 style='border-top:none;border-left:none'><%=nyou%></td>
  <td class=xl34 style='border-top:none;border-left:none'><%=油管年完成率.ToString("0.00") %></td>
  <td class=xl28 style='border-top:none;border-left:none'><%=syyou %></td>
  <td class=xl28 style='border-top:none;border-left:none'><%=snyou %></td>
  <td class=xl34 style='border-top:none;border-left:none'><%=油管同比增长率.ToString("0.00")%></td>
 </tr>
 <tr height=29 style='mso-height-source:userset;height:21.95pt'>
  <td height=29 class=xl29 style='height:21.95pt;border-top:none'>石油套管</td>
  <td class=xl28 style='border-top:none;border-left:none'>吨</td>
  <td class=xl28 style='border-top:none;border-left:none'><%=ytaojihua%></td>
  <td class=xl28 style='border-top:none;border-left:none'><%=ytao%></td>
  <td class=xl34 style='border-top:none;border-left:none'><%=套管月完成率.ToString("0.00")%></td>
  <td class=xl35 style='border-top:none;border-left:none'><%=ntaojihua%></td>
  <td class=xl28 style='border-top:none;border-left:none'><%=ntao%></td>
  <td class=xl34 style='border-top:none;border-left:none'><%=套管年完成率.ToString("0.00")%></td>
  <td class=xl28 style='border-top:none;border-left:none'><%=sytao %></td>
  <td class=xl28 style='border-top:none;border-left:none'><%=sntao %></td>
  <td class=xl34 style='border-top:none;border-left:none'><%=套管同比增长率.ToString("0.00")%></td>
 </tr>
 <tr height=29 style='mso-height-source:userset;height:21.95pt'>
  <td height=29 class=xl29 style='height:21.95pt;border-top:none'>油管接箍</td>
  <td class=xl28 style='border-top:none;border-left:none'>支</td>
  <td class=xl28 style='border-top:none;border-left:none'><%=yyjiegujihua%></td>
  <td class=xl28 style='border-top:none;border-left:none'><%=yyjiegu%></td>
  <td class=xl34 style='border-top:none;border-left:none'><%=油管接箍月完成率.ToString("0.00")%></td>
  <td class=xl35 style='border-top:none;border-left:none'><%=nyjiegujihua%></td>
  <td class=xl28 style='border-top:none;border-left:none'><%=nyjiegu%></td>
  <td class=xl34 style='border-top:none;border-left:none'><%=油管接箍年完成率.ToString("0.00")%></td>
  <td class=xl28 style='border-top:none;border-left:none'><%=syyjiegu %></td>
  <td class=xl28 style='border-top:none;border-left:none'><%=snyjiegu %></td>
  <td class=xl34 style='border-top:none;border-left:none'><%=油管接箍同比增长率.ToString("0.00")%></td>
 </tr>
 <tr height=29 style='mso-height-source:userset;height:21.95pt'>
  <td height=29 class=xl29 style='height:21.95pt;border-top:none'>套管接箍</td>
  <td class=xl28 style='border-top:none;border-left:none'>支</td>
  <td class=xl28 style='border-top:none;border-left:none'><%=ytjiegujihua%></td>
  <td class=xl28 style='border-top:none;border-left:none'><%=ytjiegu%></td>
  <td class=xl34 style='border-top:none;border-left:none'><%=套管接箍月完成率.ToString("0.00")%></td>
  <td class=xl35 style='border-top:none;border-left:none'><%=ntjiegujihua%></td>
  <td class=xl28 style='border-top:none;border-left:none'><%=ntjiegu%></td>
  <td class=xl34 style='border-top:none;border-left:none'><%=套管接箍年完成率.ToString("0.00")%></td>
  <td class=xl28 style='border-top:none;border-left:none'><%=sytjiegu %></td>
  <td class=xl28 style='border-top:none;border-left:none'><%=sntjiegu %></td>
  <td class=xl34 style='border-top:none;border-left:none'><%=套管接箍同比增长率.ToString("0.00")%></td>
 </tr>
 <tr height=29 style='mso-height-source:userset;height:21.95pt'>
  <td height=29 class=xl29 style='height:21.95pt;border-top:none'>螺纹保护器</td>
  <td class=xl28 style='border-top:none;border-left:none'>套</td>
  <td class=xl28 style='border-top:none;border-left:none'><%=ybaohuqijihua%></td>
  <td class=xl28 style='border-top:none;border-left:none'><%=ybaohuqi %></td>
  <td class=xl34 style='border-top:none;border-left:none'><%=保护器月完成率.ToString("0.00")%></td>
  <td class=xl35 style='border-top:none;border-left:none'><%=nbaohuqijihua%></td>
  <td class=xl28 style='border-top:none;border-left:none'><%=nbaohuqi%></td>
  <td class=xl34 style='border-top:none;border-left:none'><%=保护器年完成率.ToString("0.00")%></td>
  <td class=xl28 style='border-top:none;border-left:none'><%=sybaohuqi %></td>
  <td class=xl28 style='border-top:none;border-left:none'><%=snbaohuqi %></td>
  <td class=xl34 style='border-top:none;border-left:none'><%=螺纹保护器同比增长率.ToString("0.00")%></td>
 </tr>
 <tr height=29 style='mso-height-source:userset;height:21.95pt'>
  <td height=29 class=xl28 style='height:21.95pt;border-top:none'>精密带钢</td>
  <td class=xl28 style='border-top:none;border-left:none'>吨</td>
  <td class=xl28 style='border-top:none;border-left:none'><%=带钢月计划%></td>
  <td class=xl28 style='border-top:none;border-left:none'><%=带钢本月完成 %></td>
  <td class=xl34 style='border-top:none;border-left:none'><%=带钢本月完成率.ToString("0.00") %></td>
  <td class=xl35 style='border-top:none;border-left:none'><%=带钢年计划%></td>
  <td class=xl28 style='border-top:none;border-left:none'><%=带钢本年完成 %></td>
  <td class=xl34 style='border-top:none;border-left:none'><%=带钢年完成率.ToString("0.00") %></td>
  <td class=xl28 style='border-top:none;border-left:none'>　</td>
  <td class=xl28 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none' x:err="#DIV/0!"
  x:fmla="=(G11/J11-1)*100">#DIV/0!</td>
 </tr>
 <tr height=29 style='mso-height-source:userset;height:21.95pt'>
  <td height=29 class=xl32 style='height:21.95pt;border-top:none'>　</td>
  <td class=xl28 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl31 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
 </tr>
 <tr height=29 style='mso-height-source:userset;height:21.95pt'>
  <td height=29 class=xl28 style='height:21.95pt;border-top:none'>　</td>
  <td class=xl28 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl31 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
 </tr>
 <tr height=29 style='mso-height-source:userset;height:21.95pt'>
  <td height=29 class=xl28 style='height:21.95pt;border-top:none'>　</td>
  <td class=xl28 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl31 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
 </tr>
 <tr height=29 style='mso-height-source:userset;height:21.95pt'>
  <td height=29 class=xl28 style='height:21.95pt;border-top:none'>　</td>
  <td class=xl28 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl31 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
 </tr>
 <tr height=29 style='mso-height-source:userset;height:21.95pt'>
  <td height=29 class=xl28 style='height:21.95pt;border-top:none'>　</td>
  <td class=xl28 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl31 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
 </tr>
 <tr height=29 style='mso-height-source:userset;height:21.95pt'>
  <td height=29 class=xl28 style='height:21.95pt;border-top:none'>　</td>
  <td class=xl28 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl31 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
 </tr>
 <tr height=29 style='mso-height-source:userset;height:21.95pt'>
  <td height=29 class=xl28 style='height:21.95pt;border-top:none'>　</td>
  <td class=xl28 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl31 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
 </tr>
 <tr height=29 style='mso-height-source:userset;height:21.95pt'>
  <td height=29 class=xl28 style='height:21.95pt;border-top:none'>　</td>
  <td class=xl28 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl31 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
 </tr>
 <tr height=29 style='mso-height-source:userset;height:21.95pt'>
  <td height=29 class=xl33 width=117 style='height:21.95pt;border-top:none;
  width:88pt'>备 注</td>
  <td colspan=10 class=xl32 style='border-left:none'>工业总产值保留两位小数</td>
 </tr>
 <tr height=29 style='mso-height-source:userset;height:21.95pt'>
  <td colspan=2 height=29 class=xl40 style='height:21.95pt'>主管领导：焦平</td>
  <td colspan=4 class=xl41><span
  style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  </span>统计负责人：廉宝仁</td>
  <td colspan=5 class=xl42>填报人：谷立凤<span
  style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  </span>报出日期：<%=DateTime.Today.Year + "-" + DateTime.Today.Month + "-" + DateTime.Today.Day%></td>
 </tr>
 <![if supportMisalignedColumns]>
 <tr height=0 style='display:none'>
  <td width=117 style='width:88pt'></td>
  <td width=53 style='width:40pt'></td>
  <td width=85 style='width:64pt'></td>
  <td width=85 style='width:64pt'></td>
  <td width=85 style='width:64pt'></td>
  <td width=85 style='width:64pt'></td>
  <td width=85 style='width:64pt'></td>
  <td width=85 style='width:64pt'></td>
  <td width=85 style='width:64pt'></td>
  <td width=85 style='width:64pt'></td>
  <td width=85 style='width:64pt'></td>
 </tr>
 <![endif]>
</table>
      </asp:Panel>

    </form>
    
    <script type="text/javascript">
        var textboxs = document.getElementsByTagName("input");
        for (var i = 0; i < textboxs.length; i++) {
            if (textboxs[i].className == "pageturn" || textboxs[i].className == "intxt1" || textboxs[i].className == "intxt2") {
                textboxs[i].onfocus = function(e) { this.select(); };
            }
        }
        parent.hidesubmenu(true);
    </script>
</body>
</html>
